using System.Linq;
using System.Text;
using System.Diagnostics;
using System.Runtime.Serialization;
using System.Collections;
using System.Data;
using System.ComponentModel;
using System.Data.OracleClient;
using WPFExcelReport.Helpers;
using WPFExcelReport.Controls;
namespace WPFExcelReport
{
    public partial class VUSERCFG
    {
        public DataRow Convert2USERCFG(DataRow dwInput, string ITXDBVERSION, bool IsConvert = false)
        {
            DataSet SResult = new DataSet();
            SResult = QueryUSERCFG(dwInput, 0);
            DataRow dwReturn = null;
            if (SResult.Tables[0].Rows.Count > 0)
            {
                dwReturn = SResult.Tables[0].Rows[0];
            }
            else
            {
                dwReturn = SResult.Tables[0].NewRow();
            }
            switch (ITXDBVERSION)
            {
                case "YGR":
                    #region=========
         dwReturn["UCFGMANDANT"] = " ".PadRight(2 ); 
         dwReturn["UCFGUSER"] = " ".PadRight(8 ); 
         dwReturn["UCFGFKZ"] = " ".PadRight(2 ); 
         dwReturn["UCFGAENZL"] = " ".PadRight(0 ); 
         dwReturn["UCFGAENB"] = " ".PadRight(8 ); 
         dwReturn["UCFGAEND"] = " ".PadRight(0 ); 
         dwReturn["UCFGNEUB"] = " ".PadRight(8 ); 
         dwReturn["UCFGNEUD"] = " ".PadRight(0 ); 
         dwReturn["UCFGBEZ"] = " ".PadRight(50 ); 
         dwReturn["UCFGERRVR"] = " ".PadRight(0 ); 
         dwReturn["UCFGERRVG"] = " ".PadRight(0 ); 
         dwReturn["UCFGERRVB"] = " ".PadRight(0 ); 
         dwReturn["UCFGERRHR"] = " ".PadRight(0 ); 
         dwReturn["UCFGERRHG"] = " ".PadRight(0 ); 
         dwReturn["UCFGERRHB"] = " ".PadRight(0 ); 
         dwReturn["UCFGMSGVR"] = " ".PadRight(0 ); 
         dwReturn["UCFGMSGVG"] = " ".PadRight(0 ); 
         dwReturn["UCFGMSGVB"] = " ".PadRight(0 ); 
         dwReturn["UCFGMSGHR"] = " ".PadRight(0 ); 
         dwReturn["UCFGMSGHG"] = " ".PadRight(0 ); 
         dwReturn["UCFGMSGHB"] = " ".PadRight(0 ); 
         dwReturn["UCFGBACKVR"] = " ".PadRight(0 ); 
         dwReturn["UCFGBACKVG"] = " ".PadRight(0 ); 
         dwReturn["UCFGBACKVB"] = " ".PadRight(0 ); 
         dwReturn["UCFGBACKHR"] = " ".PadRight(0 ); 
         dwReturn["UCFGBACKHG"] = " ".PadRight(0 ); 
         dwReturn["UCFGBACKHB"] = " ".PadRight(0 ); 
         dwReturn["UCFGEHVR"] = " ".PadRight(0 ); 
         dwReturn["UCFGEHVG"] = " ".PadRight(0 ); 
         dwReturn["UCFGEHVB"] = " ".PadRight(0 ); 
         dwReturn["UCFGEHHR"] = " ".PadRight(0 ); 
         dwReturn["UCFGEHHG"] = " ".PadRight(0 ); 
         dwReturn["UCFGEHHB"] = " ".PadRight(0 ); 
         dwReturn["UCFGEHIVR"] = " ".PadRight(0 ); 
         dwReturn["UCFGEHIVG"] = " ".PadRight(0 ); 
         dwReturn["UCFGEHIVB"] = " ".PadRight(0 ); 
         dwReturn["UCFGEHIHR"] = " ".PadRight(0 ); 
         dwReturn["UCFGEHIHG"] = " ".PadRight(0 ); 
         dwReturn["UCFGEHIHB"] = " ".PadRight(0 ); 
         dwReturn["UCFGEHIIVR"] = " ".PadRight(0 ); 
         dwReturn["UCFGEHIIVG"] = " ".PadRight(0 ); 
         dwReturn["UCFGEHIIVB"] = " ".PadRight(0 ); 
         dwReturn["UCFGEHIIHR"] = " ".PadRight(0 ); 
         dwReturn["UCFGEHIIHG"] = " ".PadRight(0 ); 
         dwReturn["UCFGEHIIHB"] = " ".PadRight(0 ); 
         dwReturn["UCFGEPHR"] = " ".PadRight(0 ); 
         dwReturn["UCFGEPHG"] = " ".PadRight(0 ); 
         dwReturn["UCFGEPHB"] = " ".PadRight(0 ); 
         dwReturn["UCFGAHVR"] = " ".PadRight(0 ); 
         dwReturn["UCFGAHVG"] = " ".PadRight(0 ); 
         dwReturn["UCFGAHVB"] = " ".PadRight(0 ); 
         dwReturn["UCFGA1VR"] = " ".PadRight(0 ); 
         dwReturn["UCFGA1VG"] = " ".PadRight(0 ); 
         dwReturn["UCFGA1VB"] = " ".PadRight(0 ); 
         dwReturn["UCFGA2VR"] = " ".PadRight(0 ); 
         dwReturn["UCFGA2VG"] = " ".PadRight(0 ); 
         dwReturn["UCFGA2VB"] = " ".PadRight(0 ); 
         dwReturn["UCFGA3VR"] = " ".PadRight(0 ); 
         dwReturn["UCFGA3VG"] = " ".PadRight(0 ); 
         dwReturn["UCFGA3VB"] = " ".PadRight(0 ); 
         dwReturn["UCFGA4VR"] = " ".PadRight(0 ); 
         dwReturn["UCFGA4VG"] = " ".PadRight(0 ); 
         dwReturn["UCFGA4VB"] = " ".PadRight(0 ); 
         dwReturn["UCFGA5VR"] = " ".PadRight(0 ); 
         dwReturn["UCFGA5VG"] = " ".PadRight(0 ); 
         dwReturn["UCFGA5VB"] = " ".PadRight(0 ); 
         dwReturn["UCFGA6VR"] = " ".PadRight(0 ); 
         dwReturn["UCFGA6VG"] = " ".PadRight(0 ); 
         dwReturn["UCFGA6VB"] = " ".PadRight(0 ); 
         dwReturn["UCFGSCBR"] = " ".PadRight(0 ); 
         dwReturn["UCFGSCBG"] = " ".PadRight(0 ); 
         dwReturn["UCFGSCBB"] = " ".PadRight(0 ); 
         dwReturn["UCFGIFVR"] = " ".PadRight(0 ); 
         dwReturn["UCFGIFVG"] = " ".PadRight(0 ); 
         dwReturn["UCFGIFVB"] = " ".PadRight(0 ); 
         dwReturn["UCFGIFHR"] = " ".PadRight(0 ); 
         dwReturn["UCFGIFHG"] = " ".PadRight(0 ); 
         dwReturn["UCFGIFHB"] = " ".PadRight(0 ); 
         dwReturn["UCFGHELPHR"] = " ".PadRight(0 ); 
         dwReturn["UCFGHELPHG"] = " ".PadRight(0 ); 
         dwReturn["UCFGHELPHB"] = " ".PadRight(0 ); 
         dwReturn["UCFGK1R"] = " ".PadRight(0 ); 
         dwReturn["UCFGK1G"] = " ".PadRight(0 ); 
         dwReturn["UCFGK1B"] = " ".PadRight(0 ); 
         dwReturn["UCFGK2R"] = " ".PadRight(0 ); 
         dwReturn["UCFGK2G"] = " ".PadRight(0 ); 
         dwReturn["UCFGK2B"] = " ".PadRight(0 ); 
         dwReturn["UCFGS1R"] = " ".PadRight(0 ); 
         dwReturn["UCFGS1G"] = " ".PadRight(0 ); 
         dwReturn["UCFGS1B"] = " ".PadRight(0 ); 
         dwReturn["UCFGS2R"] = " ".PadRight(0 ); 
         dwReturn["UCFGS2G"] = " ".PadRight(0 ); 
         dwReturn["UCFGS2B"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESR1"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESG1"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESB1"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESR2"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESG2"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESB2"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESR3"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESG3"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESB3"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESR4"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESG4"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESB4"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESR5"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESG5"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESB5"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESR6"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESG6"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESB6"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESR7"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESG7"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESB7"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESR8"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESG8"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESB8"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESR9"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESG9"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESB9"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESR10"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESG10"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESB10"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESR11"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESG11"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESB11"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESR12"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESG12"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESB12"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESR13"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESG13"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESB13"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESR14"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESG14"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESB14"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESR15"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESG15"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESB15"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESR16"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESG16"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESB16"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESR17"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESG17"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESB17"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESR18"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESG18"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESB18"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESR19"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESG19"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESB19"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESR20"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESG20"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESB20"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESR21"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESG21"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESB21"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESR22"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESG22"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESB22"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESR23"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESG23"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESB23"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESR24"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESG24"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESB24"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESR25"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESG25"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESB25"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESR26"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESG26"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESB26"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESR27"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESG27"] = " ".PadRight(0 ); 
         dwReturn["UCFGRESB27"] = " ".PadRight(0 ); 
         dwReturn["UCFGFONT1"] = " ".PadRight(64 ); 
         dwReturn["UCFGFONT2"] = " ".PadRight(64 ); 
         dwReturn["UCFGFONT3"] = " ".PadRight(64 ); 
         dwReturn["UCFGFONT4"] = " ".PadRight(64 ); 
         dwReturn["UCFGFONT5"] = " ".PadRight(64 ); 
         dwReturn["UCFGFONT6"] = " ".PadRight(64 ); 
         dwReturn["UCFGFONT7"] = " ".PadRight(64 ); 
         dwReturn["UCFGFONT8"] = " ".PadRight(64 ); 
         dwReturn["UCFGPARMNAME1"] = " ".PadRight(16 ); 
         dwReturn["UCFGPARMWERT1"] = " ".PadRight(64 ); 
         dwReturn["UCFGPARMNAME2"] = " ".PadRight(16 ); 
         dwReturn["UCFGPARMWERT2"] = " ".PadRight(64 ); 
         dwReturn["UCFGPARMNAME3"] = " ".PadRight(16 ); 
         dwReturn["UCFGPARMWERT3"] = " ".PadRight(64 ); 
         dwReturn["UCFGPARMNAME4"] = " ".PadRight(16 ); 
         dwReturn["UCFGPARMWERT4"] = " ".PadRight(64 ); 
         dwReturn["UCFGPARMNAME5"] = " ".PadRight(16 ); 
         dwReturn["UCFGPARMWERT5"] = " ".PadRight(64 ); 
         dwReturn["UCFGPARMNAME6"] = " ".PadRight(16 ); 
         dwReturn["UCFGPARMWERT6"] = " ".PadRight(64 ); 
         dwReturn["UCFGPARMNAME7"] = " ".PadRight(16 ); 
         dwReturn["UCFGPARMWERT7"] = " ".PadRight(64 ); 
         dwReturn["UCFGPARMNAME8"] = " ".PadRight(16 ); 
         dwReturn["UCFGPARMWERT8"] = " ".PadRight(64 ); 
         dwReturn["UCFGPARMNAME9"] = " ".PadRight(16 ); 
         dwReturn["UCFGPARMWERT9"] = " ".PadRight(64 ); 
         dwReturn["UCFGPARMNAME10"] = " ".PadRight(16 ); 
         dwReturn["UCFGPARMWERT10"] = " ".PadRight(64 ); 
         dwReturn["UCFGPARMNAME11"] = " ".PadRight(16 ); 
         dwReturn["UCFGPARMWERT11"] = " ".PadRight(64 ); 
         dwReturn["UCFGPARMNAME12"] = " ".PadRight(16 ); 
         dwReturn["UCFGPARMWERT12"] = " ".PadRight(64 ); 
         dwReturn["UCFGPARMNAME13"] = " ".PadRight(16 ); 
         dwReturn["UCFGPARMWERT13"] = " ".PadRight(64 ); 
         dwReturn["UCFGPARMNAME14"] = " ".PadRight(16 ); 
         dwReturn["UCFGPARMWERT14"] = " ".PadRight(64 ); 
         dwReturn["UCFGPARMNAME15"] = " ".PadRight(16 ); 
         dwReturn["UCFGPARMWERT15"] = " ".PadRight(64 ); 
         dwReturn["UCFGPARMNAME16"] = " ".PadRight(16 ); 
         dwReturn["UCFGPARMWERT16"] = " ".PadRight(64 ); 
         dwReturn["UCFGEDITEDGE"] = " ".PadRight(1 ); 
         dwReturn["UCFGEDITY"] = " ".PadRight(0 ); 
         dwReturn["UCFGFONTFAKT1"] = " ".PadRight(0 ); 
         dwReturn["UCFGFONTFAKT2"] = " ".PadRight(0 ); 
         dwReturn["UCFGSHIFT"] = " ".PadRight(0 ); 
         dwReturn["UCFGZUONR1"] = " ".PadRight(0 ); 
         dwReturn["UCFGZUONR2"] = " ".PadRight(0 ); 
         dwReturn["UCFGZUONR3"] = " ".PadRight(0 ); 
         dwReturn["UCFGZUONR4"] = " ".PadRight(0 ); 
         dwReturn["UCFGZUONR5"] = " ".PadRight(0 ); 
         dwReturn["UCFGZUONR6"] = " ".PadRight(0 ); 
         dwReturn["UCFGZUONR7"] = " ".PadRight(0 ); 
         dwReturn["UCFGZUONR8"] = " ".PadRight(0 ); 
         dwReturn["UCFGZUONR9"] = " ".PadRight(0 ); 
         dwReturn["UCFGZUONR10"] = " ".PadRight(0 ); 
         dwReturn["UCFGZUONR11"] = " ".PadRight(0 ); 
         dwReturn["UCFGZUONR12"] = " ".PadRight(0 ); 
         dwReturn["UCFGZUONR13"] = " ".PadRight(0 ); 
         dwReturn["UCFGZUONR14"] = " ".PadRight(0 ); 
         dwReturn["UCFGZUONR15"] = " ".PadRight(0 ); 
         dwReturn["UCFGZUONR16"] = " ".PadRight(0 ); 
         dwReturn["UCFGZUONR17"] = " ".PadRight(0 ); 
         dwReturn["UCFGZUONR18"] = " ".PadRight(0 ); 
         dwReturn["UCFGZUONR19"] = " ".PadRight(0 ); 
         dwReturn["UCFGZUONR20"] = " ".PadRight(0 ); 
         dwReturn["UCFGZUONR21"] = " ".PadRight(0 ); 
         dwReturn["UCFGZUONR22"] = " ".PadRight(0 ); 
         dwReturn["UCFGZUONR23"] = " ".PadRight(0 ); 
         dwReturn["UCFGZUONR24"] = " ".PadRight(0 ); 
         dwReturn["UCFGZUONR25"] = " ".PadRight(0 ); 
         dwReturn["UCFGZUONR26"] = " ".PadRight(0 ); 
         dwReturn["UCFGZUONR27"] = " ".PadRight(0 ); 
         dwReturn["UCFGZUONR28"] = " ".PadRight(0 ); 
         dwReturn["UCFGZUONR29"] = " ".PadRight(0 ); 
         dwReturn["UCFGZUONR30"] = " ".PadRight(0 ); 
         dwReturn["UCFGZUONR31"] = " ".PadRight(0 ); 
         dwReturn["UCFGZUONR32"] = " ".PadRight(0 ); 
         dwReturn["UCFGZUONR33"] = " ".PadRight(0 ); 
         dwReturn["UCFGZUONR34"] = " ".PadRight(0 ); 
         dwReturn["UCFGZUONR35"] = " ".PadRight(0 ); 
         dwReturn["UCFGZUONR36"] = " ".PadRight(0 ); 
         dwReturn["UCFGZUONR37"] = " ".PadRight(0 ); 
         dwReturn["UCFGZUONR38"] = " ".PadRight(0 ); 
         dwReturn["UCFGZUONR39"] = " ".PadRight(0 ); 
         dwReturn["UCFGZUONR40"] = " ".PadRight(0 ); 
         dwReturn["UCFGZUONR41"] = " ".PadRight(0 ); 
         dwReturn["UCFGZUONR42"] = " ".PadRight(0 ); 
         dwReturn["UCFGZUONR43"] = " ".PadRight(0 ); 
         dwReturn["UCFGZUONR44"] = " ".PadRight(0 ); 
         dwReturn["UCFGZUONR45"] = " ".PadRight(0 ); 
         dwReturn["UCFGZUONR46"] = " ".PadRight(0 ); 
         dwReturn["UCFGZUONR47"] = " ".PadRight(0 ); 
         dwReturn["UCFGZUONR48"] = " ".PadRight(0 ); 
         dwReturn["UCFGZUONR49"] = " ".PadRight(0 ); 
         dwReturn["UCFGZUONR50"] = " ".PadRight(0 ); 
         dwReturn["UCFGFILLER1"] = " ".PadRight(892 ); 
         dwReturn["UCFGFILLER2"] = " ".PadRight(789 ); 
                    #endregion
                    break;
                case "JLT":

                    break;
                default:

                    break;
            }
            if (IsConvert)
            {
                foreach (DataColumn cm in dwInput.Table.Columns)
                {
                    if (dwInput[cm.ColumnName].ToString() == "")
                        continue;
                    if (dwReturn.Table.Columns.Contains(cm.ColumnName))
                    {
                        dwReturn[cm.ColumnName] = dwInput[cm.ColumnName];
                    }
                }
            }
            return dwReturn;
        }
        public void MapUSERCFG(ref DataRow dwLocal, DataRow dwData)
        {
            BlindMap(ref dwLocal, dwData);
        }
        public void SaveUSERCFG(DataRow dwData, string ITXDBVERSION = "50.24")
        {
            DataSet setResult = new DataSet();
            DataTable tbLocal = null;
            DataRow dwLocal = null;
            bool flgExist = false;
            setResult = QueryUSERCFG(dwData);
            if (setResult.Tables.Count > 0)
            {
                tbLocal = setResult.Tables[0];
                if (tbLocal.Rows.Count > 0)
                {
                    flgExist = true;
                    dwLocal = tbLocal.Rows[0];
                }
                else
                {
                    dwLocal = tbLocal.NewRow();
                }
            }
            MapUSERCFG(ref dwLocal, dwData);

            if (!flgExist)
            {

                InsertUSERCFG(dwLocal, ITXDBVERSION);
            }
            UpdateUSERCFG(dwLocal);
        }
        public void InsertUSERCFG(DataRow dwData, string ITXDBVERSION = "50.24")
        {
            OracleCommand or1;
            or1 = OracleDB.CreateCommand();
            switch (ITXDBVERSION)
            {
                case "YGR":
                    or1.CommandText = "INSERT INTO USERCFG(VAKBMANDANT, VAKBKOLL, VAKBART, VAKBKUNDNR, VAKBFARBE, VAKBKDARTNR, VAKBKDARTBEZ, VAKBKDFARBNR, VAKBANDRUCK, VAKBMEGEW, VAKBMENGEH, VAKBGEWVON, VAKBGEWBIS, VAKBGEWCA, VAKBGEWFKT, VAKBGEWGRP, VAKBMEGFKT, VAKBMEGGRP, VAKBAENDZL, VAKBAENDBEN, VAKBAENDDAT, VAKBNEUBEN, VAKBNEUDAT, VAKBFILLER)"
                        + " VALUES (:VAKBMANDANT, :VAKBKOLL, :VAKBART, :VAKBKUNDNR, :VAKBFARBE, '                         ', '                         ', '                             ', ' ', '   ', '   ', 0, 0, ' ', '000000000000', ' ', '000000000000', ' ', 0, '        ', '000000', '        ', '      ', '                                          ')";
                    or1.Parameters.Add("VAKBMANDANT", OracleType.NVarChar).Value = dwData["VAKBMANDANT"].ToString();
                    or1.Parameters.Add("VAKBKOLL", OracleType.NVarChar).Value = dwData["VAKBKOLL"].ToString();
                    or1.Parameters.Add("VAKBART", OracleType.NVarChar).Value = dwData["VAKBART"].ToString();
                    or1.Parameters.Add("VAKBFARBE", OracleType.NVarChar).Value = dwData["VAKBFARBE"].ToString();
                    or1.Parameters.Add("VAKBKUNDNR", OracleType.NVarChar).Value = dwData["VAKBKUNDNR"].ToString();
                    break;
                //VAFMANDANT VAFKOLL VAFART VAFFARBE VAFBEZ VAFFFARBE

            }
            
            Connect2Proxy(or1);
        }
        public DataSet QueryUSERCFG(DataRow dwData, int option = 1)
        {
            DataSet Return;
            DataSet Result = new DataSet();
            OracleCommand or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 0:
                    or1.CommandText = "SELECT * FROM USERCFG WHERE  ROWNUM<2 ";
                    break;
              
                case 99:
                    or1.CommandText = "SELECT * FROM USERCFG  WHERE ROWNUM<50";
                    break;
                default:
                    break;
            }
            Result = Connect2Proxy(or1);
            if (Result.Tables.Count > 0)
                Result.Tables[0].TableName = "USERCFG";
            Return = Result;
            return Return;
        }
        public void DeleteUSERCFG(DataRow dwData, int option = 1)
        {

            OracleCommand or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 1:
                    or1.CommandText = "DELETE FROM USERCFG   WHERE  VAKBMANDANT=:VAKBMANDANT AND VAKBKOLL=:VAKBKOLL AND VAKBART =:VAKBART AND VAKBFARBE=:VAKBFARBE AND VAKBKUNDNR=:VAKBKUNDNR";
                     or1.Parameters.Add("VAKBMANDANT", OracleType.NVarChar).Value = dwData["VAKBMANDANT"].ToString();
                    or1.Parameters.Add("VAKBKOLL", OracleType.NVarChar).Value = dwData["VAKBKOLL"].ToString();
                    or1.Parameters.Add("VAKBART", OracleType.NVarChar).Value = dwData["VAKBART"].ToString();
                    or1.Parameters.Add("VAKBFARBE", OracleType.NVarChar).Value = dwData["VAKBFARBE"].ToString();
                    or1.Parameters.Add("VAKBKUNDNR", OracleType.NVarChar).Value = dwData["VAKBKUNDNR"].ToString();
                    break;
                default:
                    break;
            }
            Connect2Proxy(or1);
        } 
      
        public void UpdateUSERCFG(DataRow dwData, string ITXDBVERSION = "50.24", int option = 1)
        {
            OracleCommand or1;
            DataSet Result = new DataSet();
            or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 1:
                    #region====Command==== 
                    or1.CommandText = "UPDATE USERCFG SET "
                    +"UCFGMANDANT= :UCFGMANDANT,"
                    +"UCFGUSER= :UCFGUSER,"
                    +"UCFGFKZ= :UCFGFKZ,"
                    +"UCFGAENZL= :UCFGAENZL,"
                    +"UCFGAENB= :UCFGAENB,"
                    +"UCFGAEND= :UCFGAEND,"
                    +"UCFGNEUB= :UCFGNEUB,"
                    +"UCFGNEUD= :UCFGNEUD,"
                    +"UCFGBEZ= :UCFGBEZ,"
                    +"UCFGERRVR= :UCFGERRVR,"
                    +"UCFGERRVG= :UCFGERRVG,"
                    +"UCFGERRVB= :UCFGERRVB,"
                    +"UCFGERRHR= :UCFGERRHR,"
                    +"UCFGERRHG= :UCFGERRHG,"
                    +"UCFGERRHB= :UCFGERRHB,"
                    +"UCFGMSGVR= :UCFGMSGVR,"
                    +"UCFGMSGVG= :UCFGMSGVG,"
                    +"UCFGMSGVB= :UCFGMSGVB,"
                    +"UCFGMSGHR= :UCFGMSGHR,"
                    +"UCFGMSGHG= :UCFGMSGHG,"
                    +"UCFGMSGHB= :UCFGMSGHB,"
                    +"UCFGBACKVR= :UCFGBACKVR,"
                    +"UCFGBACKVG= :UCFGBACKVG,"
                    +"UCFGBACKVB= :UCFGBACKVB,"
                    +"UCFGBACKHR= :UCFGBACKHR,"
                    +"UCFGBACKHG= :UCFGBACKHG,"
                    +"UCFGBACKHB= :UCFGBACKHB,"
                    +"UCFGEHVR= :UCFGEHVR,"
                    +"UCFGEHVG= :UCFGEHVG,"
                    +"UCFGEHVB= :UCFGEHVB,"
                    +"UCFGEHHR= :UCFGEHHR,"
                    +"UCFGEHHG= :UCFGEHHG,"
                    +"UCFGEHHB= :UCFGEHHB,"
                    +"UCFGEHIVR= :UCFGEHIVR,"
                    +"UCFGEHIVG= :UCFGEHIVG,"
                    +"UCFGEHIVB= :UCFGEHIVB,"
                    +"UCFGEHIHR= :UCFGEHIHR,"
                    +"UCFGEHIHG= :UCFGEHIHG,"
                    +"UCFGEHIHB= :UCFGEHIHB,"
                    +"UCFGEHIIVR= :UCFGEHIIVR,"
                    +"UCFGEHIIVG= :UCFGEHIIVG,"
                    +"UCFGEHIIVB= :UCFGEHIIVB,"
                    +"UCFGEHIIHR= :UCFGEHIIHR,"
                    +"UCFGEHIIHG= :UCFGEHIIHG,"
                    +"UCFGEHIIHB= :UCFGEHIIHB,"
                    +"UCFGEPHR= :UCFGEPHR,"
                    +"UCFGEPHG= :UCFGEPHG,"
                    +"UCFGEPHB= :UCFGEPHB,"
                    +"UCFGAHVR= :UCFGAHVR,"
                    +"UCFGAHVG= :UCFGAHVG,"
                    +"UCFGAHVB= :UCFGAHVB,"
                    +"UCFGA1VR= :UCFGA1VR,"
                    +"UCFGA1VG= :UCFGA1VG,"
                    +"UCFGA1VB= :UCFGA1VB,"
                    +"UCFGA2VR= :UCFGA2VR,"
                    +"UCFGA2VG= :UCFGA2VG,"
                    +"UCFGA2VB= :UCFGA2VB,"
                    +"UCFGA3VR= :UCFGA3VR,"
                    +"UCFGA3VG= :UCFGA3VG,"
                    +"UCFGA3VB= :UCFGA3VB,"
                    +"UCFGA4VR= :UCFGA4VR,"
                    +"UCFGA4VG= :UCFGA4VG,"
                    +"UCFGA4VB= :UCFGA4VB,"
                    +"UCFGA5VR= :UCFGA5VR,"
                    +"UCFGA5VG= :UCFGA5VG,"
                    +"UCFGA5VB= :UCFGA5VB,"
                    +"UCFGA6VR= :UCFGA6VR,"
                    +"UCFGA6VG= :UCFGA6VG,"
                    +"UCFGA6VB= :UCFGA6VB,"
                    +"UCFGSCBR= :UCFGSCBR,"
                    +"UCFGSCBG= :UCFGSCBG,"
                    +"UCFGSCBB= :UCFGSCBB,"
                    +"UCFGIFVR= :UCFGIFVR,"
                    +"UCFGIFVG= :UCFGIFVG,"
                    +"UCFGIFVB= :UCFGIFVB,"
                    +"UCFGIFHR= :UCFGIFHR,"
                    +"UCFGIFHG= :UCFGIFHG,"
                    +"UCFGIFHB= :UCFGIFHB,"
                    +"UCFGHELPHR= :UCFGHELPHR,"
                    +"UCFGHELPHG= :UCFGHELPHG,"
                    +"UCFGHELPHB= :UCFGHELPHB,"
                    +"UCFGK1R= :UCFGK1R,"
                    +"UCFGK1G= :UCFGK1G,"
                    +"UCFGK1B= :UCFGK1B,"
                    +"UCFGK2R= :UCFGK2R,"
                    +"UCFGK2G= :UCFGK2G,"
                    +"UCFGK2B= :UCFGK2B,"
                    +"UCFGS1R= :UCFGS1R,"
                    +"UCFGS1G= :UCFGS1G,"
                    +"UCFGS1B= :UCFGS1B,"
                    +"UCFGS2R= :UCFGS2R,"
                    +"UCFGS2G= :UCFGS2G,"
                    +"UCFGS2B= :UCFGS2B,"
                    +"UCFGRESR1= :UCFGRESR1,"
                    +"UCFGRESG1= :UCFGRESG1,"
                    +"UCFGRESB1= :UCFGRESB1,"
                    +"UCFGRESR2= :UCFGRESR2,"
                    +"UCFGRESG2= :UCFGRESG2,"
                    +"UCFGRESB2= :UCFGRESB2,"
                    +"UCFGRESR3= :UCFGRESR3,"
                    +"UCFGRESG3= :UCFGRESG3,"
                    +"UCFGRESB3= :UCFGRESB3,"
                    +"UCFGRESR4= :UCFGRESR4,"
                    +"UCFGRESG4= :UCFGRESG4,"
                    +"UCFGRESB4= :UCFGRESB4,"
                    +"UCFGRESR5= :UCFGRESR5,"
                    +"UCFGRESG5= :UCFGRESG5,"
                    +"UCFGRESB5= :UCFGRESB5,"
                    +"UCFGRESR6= :UCFGRESR6,"
                    +"UCFGRESG6= :UCFGRESG6,"
                    +"UCFGRESB6= :UCFGRESB6,"
                    +"UCFGRESR7= :UCFGRESR7,"
                    +"UCFGRESG7= :UCFGRESG7,"
                    +"UCFGRESB7= :UCFGRESB7,"
                    +"UCFGRESR8= :UCFGRESR8,"
                    +"UCFGRESG8= :UCFGRESG8,"
                    +"UCFGRESB8= :UCFGRESB8,"
                    +"UCFGRESR9= :UCFGRESR9,"
                    +"UCFGRESG9= :UCFGRESG9,"
                    +"UCFGRESB9= :UCFGRESB9,"
                    +"UCFGRESR10= :UCFGRESR10,"
                    +"UCFGRESG10= :UCFGRESG10,"
                    +"UCFGRESB10= :UCFGRESB10,"
                    +"UCFGRESR11= :UCFGRESR11,"
                    +"UCFGRESG11= :UCFGRESG11,"
                    +"UCFGRESB11= :UCFGRESB11,"
                    +"UCFGRESR12= :UCFGRESR12,"
                    +"UCFGRESG12= :UCFGRESG12,"
                    +"UCFGRESB12= :UCFGRESB12,"
                    +"UCFGRESR13= :UCFGRESR13,"
                    +"UCFGRESG13= :UCFGRESG13,"
                    +"UCFGRESB13= :UCFGRESB13,"
                    +"UCFGRESR14= :UCFGRESR14,"
                    +"UCFGRESG14= :UCFGRESG14,"
                    +"UCFGRESB14= :UCFGRESB14,"
                    +"UCFGRESR15= :UCFGRESR15,"
                    +"UCFGRESG15= :UCFGRESG15,"
                    +"UCFGRESB15= :UCFGRESB15,"
                    +"UCFGRESR16= :UCFGRESR16,"
                    +"UCFGRESG16= :UCFGRESG16,"
                    +"UCFGRESB16= :UCFGRESB16,"
                    +"UCFGRESR17= :UCFGRESR17,"
                    +"UCFGRESG17= :UCFGRESG17,"
                    +"UCFGRESB17= :UCFGRESB17,"
                    +"UCFGRESR18= :UCFGRESR18,"
                    +"UCFGRESG18= :UCFGRESG18,"
                    +"UCFGRESB18= :UCFGRESB18,"
                    +"UCFGRESR19= :UCFGRESR19,"
                    +"UCFGRESG19= :UCFGRESG19,"
                    +"UCFGRESB19= :UCFGRESB19,"
                    +"UCFGRESR20= :UCFGRESR20,"
                    +"UCFGRESG20= :UCFGRESG20,"
                    +"UCFGRESB20= :UCFGRESB20,"
                    +"UCFGRESR21= :UCFGRESR21,"
                    +"UCFGRESG21= :UCFGRESG21,"
                    +"UCFGRESB21= :UCFGRESB21,"
                    +"UCFGRESR22= :UCFGRESR22,"
                    +"UCFGRESG22= :UCFGRESG22,"
                    +"UCFGRESB22= :UCFGRESB22,"
                    +"UCFGRESR23= :UCFGRESR23,"
                    +"UCFGRESG23= :UCFGRESG23,"
                    +"UCFGRESB23= :UCFGRESB23,"
                    +"UCFGRESR24= :UCFGRESR24,"
                    +"UCFGRESG24= :UCFGRESG24,"
                    +"UCFGRESB24= :UCFGRESB24,"
                    +"UCFGRESR25= :UCFGRESR25,"
                    +"UCFGRESG25= :UCFGRESG25,"
                    +"UCFGRESB25= :UCFGRESB25,"
                    +"UCFGRESR26= :UCFGRESR26,"
                    +"UCFGRESG26= :UCFGRESG26,"
                    +"UCFGRESB26= :UCFGRESB26,"
                    +"UCFGRESR27= :UCFGRESR27,"
                    +"UCFGRESG27= :UCFGRESG27,"
                    +"UCFGRESB27= :UCFGRESB27,"
                    +"UCFGFONT1= :UCFGFONT1,"
                    +"UCFGFONT2= :UCFGFONT2,"
                    +"UCFGFONT3= :UCFGFONT3,"
                    +"UCFGFONT4= :UCFGFONT4,"
                    +"UCFGFONT5= :UCFGFONT5,"
                    +"UCFGFONT6= :UCFGFONT6,"
                    +"UCFGFONT7= :UCFGFONT7,"
                    +"UCFGFONT8= :UCFGFONT8,"
                    +"UCFGPARMNAME1= :UCFGPARMNAME1,"
                    +"UCFGPARMWERT1= :UCFGPARMWERT1,"
                    +"UCFGPARMNAME2= :UCFGPARMNAME2,"
                    +"UCFGPARMWERT2= :UCFGPARMWERT2,"
                    +"UCFGPARMNAME3= :UCFGPARMNAME3,"
                    +"UCFGPARMWERT3= :UCFGPARMWERT3,"
                    +"UCFGPARMNAME4= :UCFGPARMNAME4,"
                    +"UCFGPARMWERT4= :UCFGPARMWERT4,"
                    +"UCFGPARMNAME5= :UCFGPARMNAME5,"
                    +"UCFGPARMWERT5= :UCFGPARMWERT5,"
                    +"UCFGPARMNAME6= :UCFGPARMNAME6,"
                    +"UCFGPARMWERT6= :UCFGPARMWERT6,"
                    +"UCFGPARMNAME7= :UCFGPARMNAME7,"
                    +"UCFGPARMWERT7= :UCFGPARMWERT7,"
                    +"UCFGPARMNAME8= :UCFGPARMNAME8,"
                    +"UCFGPARMWERT8= :UCFGPARMWERT8,"
                    +"UCFGPARMNAME9= :UCFGPARMNAME9,"
                    +"UCFGPARMWERT9= :UCFGPARMWERT9,"
                    +"UCFGPARMNAME10= :UCFGPARMNAME10,"
                    +"UCFGPARMWERT10= :UCFGPARMWERT10,"
                    +"UCFGPARMNAME11= :UCFGPARMNAME11,"
                    +"UCFGPARMWERT11= :UCFGPARMWERT11,"
                    +"UCFGPARMNAME12= :UCFGPARMNAME12,"
                    +"UCFGPARMWERT12= :UCFGPARMWERT12,"
                    +"UCFGPARMNAME13= :UCFGPARMNAME13,"
                    +"UCFGPARMWERT13= :UCFGPARMWERT13,"
                    +"UCFGPARMNAME14= :UCFGPARMNAME14,"
                    +"UCFGPARMWERT14= :UCFGPARMWERT14,"
                    +"UCFGPARMNAME15= :UCFGPARMNAME15,"
                    +"UCFGPARMWERT15= :UCFGPARMWERT15,"
                    +"UCFGPARMNAME16= :UCFGPARMNAME16,"
                    +"UCFGPARMWERT16= :UCFGPARMWERT16,"
                    +"UCFGEDITEDGE= :UCFGEDITEDGE,"
                    +"UCFGEDITY= :UCFGEDITY,"
                    +"UCFGFONTFAKT1= :UCFGFONTFAKT1,"
                    +"UCFGFONTFAKT2= :UCFGFONTFAKT2,"
                    +"UCFGSHIFT= :UCFGSHIFT,"
                    +"UCFGZUONR1= :UCFGZUONR1,"
                    +"UCFGZUONR2= :UCFGZUONR2,"
                    +"UCFGZUONR3= :UCFGZUONR3,"
                    +"UCFGZUONR4= :UCFGZUONR4,"
                    +"UCFGZUONR5= :UCFGZUONR5,"
                    +"UCFGZUONR6= :UCFGZUONR6,"
                    +"UCFGZUONR7= :UCFGZUONR7,"
                    +"UCFGZUONR8= :UCFGZUONR8,"
                    +"UCFGZUONR9= :UCFGZUONR9,"
                    +"UCFGZUONR10= :UCFGZUONR10,"
                    +"UCFGZUONR11= :UCFGZUONR11,"
                    +"UCFGZUONR12= :UCFGZUONR12,"
                    +"UCFGZUONR13= :UCFGZUONR13,"
                    +"UCFGZUONR14= :UCFGZUONR14,"
                    +"UCFGZUONR15= :UCFGZUONR15,"
                    +"UCFGZUONR16= :UCFGZUONR16,"
                    +"UCFGZUONR17= :UCFGZUONR17,"
                    +"UCFGZUONR18= :UCFGZUONR18,"
                    +"UCFGZUONR19= :UCFGZUONR19,"
                    +"UCFGZUONR20= :UCFGZUONR20,"
                    +"UCFGZUONR21= :UCFGZUONR21,"
                    +"UCFGZUONR22= :UCFGZUONR22,"
                    +"UCFGZUONR23= :UCFGZUONR23,"
                    +"UCFGZUONR24= :UCFGZUONR24,"
                    +"UCFGZUONR25= :UCFGZUONR25,"
                    +"UCFGZUONR26= :UCFGZUONR26,"
                    +"UCFGZUONR27= :UCFGZUONR27,"
                    +"UCFGZUONR28= :UCFGZUONR28,"
                    +"UCFGZUONR29= :UCFGZUONR29,"
                    +"UCFGZUONR30= :UCFGZUONR30,"
                    +"UCFGZUONR31= :UCFGZUONR31,"
                    +"UCFGZUONR32= :UCFGZUONR32,"
                    +"UCFGZUONR33= :UCFGZUONR33,"
                    +"UCFGZUONR34= :UCFGZUONR34,"
                    +"UCFGZUONR35= :UCFGZUONR35,"
                    +"UCFGZUONR36= :UCFGZUONR36,"
                    +"UCFGZUONR37= :UCFGZUONR37,"
                    +"UCFGZUONR38= :UCFGZUONR38,"
                    +"UCFGZUONR39= :UCFGZUONR39,"
                    +"UCFGZUONR40= :UCFGZUONR40,"
                    +"UCFGZUONR41= :UCFGZUONR41,"
                    +"UCFGZUONR42= :UCFGZUONR42,"
                    +"UCFGZUONR43= :UCFGZUONR43,"
                    +"UCFGZUONR44= :UCFGZUONR44,"
                    +"UCFGZUONR45= :UCFGZUONR45,"
                    +"UCFGZUONR46= :UCFGZUONR46,"
                    +"UCFGZUONR47= :UCFGZUONR47,"
                    +"UCFGZUONR48= :UCFGZUONR48,"
                    +"UCFGZUONR49= :UCFGZUONR49,"
                    +"UCFGZUONR50= :UCFGZUONR50,"
                    +"UCFGFILLER1= :UCFGFILLER1,"
                    +"UCFGFILLER2= :UCFGFILLER2,"
                        + " WHERE  "
                        + "  VAKBMANDANT=:VAKBMANDANT AND VAKBKOLL=:VAKBKOLL AND VAKBART =:VAKBART AND VAKBFARBE=:VAKBFARBE AND VAKBKUNDNR=:VAKBKUNDNR";
                    #endregion

                    #region====Parameters====
          or1.Parameters.Add("UCFGMANDANT", OracleType.NVarChar).Value = dwData["UCFGMANDANT"].ToString(); 
          or1.Parameters.Add("UCFGUSER", OracleType.NVarChar).Value = dwData["UCFGUSER"].ToString(); 
          or1.Parameters.Add("UCFGFKZ", OracleType.NVarChar).Value = dwData["UCFGFKZ"].ToString(); 
          or1.Parameters.Add("UCFGAENZL", OracleType.NVarChar).Value = dwData["UCFGAENZL"].ToString(); 
          or1.Parameters.Add("UCFGAENB", OracleType.NVarChar).Value = dwData["UCFGAENB"].ToString(); 
          or1.Parameters.Add("UCFGAEND", OracleType.NVarChar).Value = dwData["UCFGAEND"].ToString(); 
          or1.Parameters.Add("UCFGNEUB", OracleType.NVarChar).Value = dwData["UCFGNEUB"].ToString(); 
          or1.Parameters.Add("UCFGNEUD", OracleType.NVarChar).Value = dwData["UCFGNEUD"].ToString(); 
          or1.Parameters.Add("UCFGBEZ", OracleType.NVarChar).Value = dwData["UCFGBEZ"].ToString(); 
          or1.Parameters.Add("UCFGERRVR", OracleType.NVarChar).Value = dwData["UCFGERRVR"].ToString(); 
          or1.Parameters.Add("UCFGERRVG", OracleType.NVarChar).Value = dwData["UCFGERRVG"].ToString(); 
          or1.Parameters.Add("UCFGERRVB", OracleType.NVarChar).Value = dwData["UCFGERRVB"].ToString(); 
          or1.Parameters.Add("UCFGERRHR", OracleType.NVarChar).Value = dwData["UCFGERRHR"].ToString(); 
          or1.Parameters.Add("UCFGERRHG", OracleType.NVarChar).Value = dwData["UCFGERRHG"].ToString(); 
          or1.Parameters.Add("UCFGERRHB", OracleType.NVarChar).Value = dwData["UCFGERRHB"].ToString(); 
          or1.Parameters.Add("UCFGMSGVR", OracleType.NVarChar).Value = dwData["UCFGMSGVR"].ToString(); 
          or1.Parameters.Add("UCFGMSGVG", OracleType.NVarChar).Value = dwData["UCFGMSGVG"].ToString(); 
          or1.Parameters.Add("UCFGMSGVB", OracleType.NVarChar).Value = dwData["UCFGMSGVB"].ToString(); 
          or1.Parameters.Add("UCFGMSGHR", OracleType.NVarChar).Value = dwData["UCFGMSGHR"].ToString(); 
          or1.Parameters.Add("UCFGMSGHG", OracleType.NVarChar).Value = dwData["UCFGMSGHG"].ToString(); 
          or1.Parameters.Add("UCFGMSGHB", OracleType.NVarChar).Value = dwData["UCFGMSGHB"].ToString(); 
          or1.Parameters.Add("UCFGBACKVR", OracleType.NVarChar).Value = dwData["UCFGBACKVR"].ToString(); 
          or1.Parameters.Add("UCFGBACKVG", OracleType.NVarChar).Value = dwData["UCFGBACKVG"].ToString(); 
          or1.Parameters.Add("UCFGBACKVB", OracleType.NVarChar).Value = dwData["UCFGBACKVB"].ToString(); 
          or1.Parameters.Add("UCFGBACKHR", OracleType.NVarChar).Value = dwData["UCFGBACKHR"].ToString(); 
          or1.Parameters.Add("UCFGBACKHG", OracleType.NVarChar).Value = dwData["UCFGBACKHG"].ToString(); 
          or1.Parameters.Add("UCFGBACKHB", OracleType.NVarChar).Value = dwData["UCFGBACKHB"].ToString(); 
          or1.Parameters.Add("UCFGEHVR", OracleType.NVarChar).Value = dwData["UCFGEHVR"].ToString(); 
          or1.Parameters.Add("UCFGEHVG", OracleType.NVarChar).Value = dwData["UCFGEHVG"].ToString(); 
          or1.Parameters.Add("UCFGEHVB", OracleType.NVarChar).Value = dwData["UCFGEHVB"].ToString(); 
          or1.Parameters.Add("UCFGEHHR", OracleType.NVarChar).Value = dwData["UCFGEHHR"].ToString(); 
          or1.Parameters.Add("UCFGEHHG", OracleType.NVarChar).Value = dwData["UCFGEHHG"].ToString(); 
          or1.Parameters.Add("UCFGEHHB", OracleType.NVarChar).Value = dwData["UCFGEHHB"].ToString(); 
          or1.Parameters.Add("UCFGEHIVR", OracleType.NVarChar).Value = dwData["UCFGEHIVR"].ToString(); 
          or1.Parameters.Add("UCFGEHIVG", OracleType.NVarChar).Value = dwData["UCFGEHIVG"].ToString(); 
          or1.Parameters.Add("UCFGEHIVB", OracleType.NVarChar).Value = dwData["UCFGEHIVB"].ToString(); 
          or1.Parameters.Add("UCFGEHIHR", OracleType.NVarChar).Value = dwData["UCFGEHIHR"].ToString(); 
          or1.Parameters.Add("UCFGEHIHG", OracleType.NVarChar).Value = dwData["UCFGEHIHG"].ToString(); 
          or1.Parameters.Add("UCFGEHIHB", OracleType.NVarChar).Value = dwData["UCFGEHIHB"].ToString(); 
          or1.Parameters.Add("UCFGEHIIVR", OracleType.NVarChar).Value = dwData["UCFGEHIIVR"].ToString(); 
          or1.Parameters.Add("UCFGEHIIVG", OracleType.NVarChar).Value = dwData["UCFGEHIIVG"].ToString(); 
          or1.Parameters.Add("UCFGEHIIVB", OracleType.NVarChar).Value = dwData["UCFGEHIIVB"].ToString(); 
          or1.Parameters.Add("UCFGEHIIHR", OracleType.NVarChar).Value = dwData["UCFGEHIIHR"].ToString(); 
          or1.Parameters.Add("UCFGEHIIHG", OracleType.NVarChar).Value = dwData["UCFGEHIIHG"].ToString(); 
          or1.Parameters.Add("UCFGEHIIHB", OracleType.NVarChar).Value = dwData["UCFGEHIIHB"].ToString(); 
          or1.Parameters.Add("UCFGEPHR", OracleType.NVarChar).Value = dwData["UCFGEPHR"].ToString(); 
          or1.Parameters.Add("UCFGEPHG", OracleType.NVarChar).Value = dwData["UCFGEPHG"].ToString(); 
          or1.Parameters.Add("UCFGEPHB", OracleType.NVarChar).Value = dwData["UCFGEPHB"].ToString(); 
          or1.Parameters.Add("UCFGAHVR", OracleType.NVarChar).Value = dwData["UCFGAHVR"].ToString(); 
          or1.Parameters.Add("UCFGAHVG", OracleType.NVarChar).Value = dwData["UCFGAHVG"].ToString(); 
          or1.Parameters.Add("UCFGAHVB", OracleType.NVarChar).Value = dwData["UCFGAHVB"].ToString(); 
          or1.Parameters.Add("UCFGA1VR", OracleType.NVarChar).Value = dwData["UCFGA1VR"].ToString(); 
          or1.Parameters.Add("UCFGA1VG", OracleType.NVarChar).Value = dwData["UCFGA1VG"].ToString(); 
          or1.Parameters.Add("UCFGA1VB", OracleType.NVarChar).Value = dwData["UCFGA1VB"].ToString(); 
          or1.Parameters.Add("UCFGA2VR", OracleType.NVarChar).Value = dwData["UCFGA2VR"].ToString(); 
          or1.Parameters.Add("UCFGA2VG", OracleType.NVarChar).Value = dwData["UCFGA2VG"].ToString(); 
          or1.Parameters.Add("UCFGA2VB", OracleType.NVarChar).Value = dwData["UCFGA2VB"].ToString(); 
          or1.Parameters.Add("UCFGA3VR", OracleType.NVarChar).Value = dwData["UCFGA3VR"].ToString(); 
          or1.Parameters.Add("UCFGA3VG", OracleType.NVarChar).Value = dwData["UCFGA3VG"].ToString(); 
          or1.Parameters.Add("UCFGA3VB", OracleType.NVarChar).Value = dwData["UCFGA3VB"].ToString(); 
          or1.Parameters.Add("UCFGA4VR", OracleType.NVarChar).Value = dwData["UCFGA4VR"].ToString(); 
          or1.Parameters.Add("UCFGA4VG", OracleType.NVarChar).Value = dwData["UCFGA4VG"].ToString(); 
          or1.Parameters.Add("UCFGA4VB", OracleType.NVarChar).Value = dwData["UCFGA4VB"].ToString(); 
          or1.Parameters.Add("UCFGA5VR", OracleType.NVarChar).Value = dwData["UCFGA5VR"].ToString(); 
          or1.Parameters.Add("UCFGA5VG", OracleType.NVarChar).Value = dwData["UCFGA5VG"].ToString(); 
          or1.Parameters.Add("UCFGA5VB", OracleType.NVarChar).Value = dwData["UCFGA5VB"].ToString(); 
          or1.Parameters.Add("UCFGA6VR", OracleType.NVarChar).Value = dwData["UCFGA6VR"].ToString(); 
          or1.Parameters.Add("UCFGA6VG", OracleType.NVarChar).Value = dwData["UCFGA6VG"].ToString(); 
          or1.Parameters.Add("UCFGA6VB", OracleType.NVarChar).Value = dwData["UCFGA6VB"].ToString(); 
          or1.Parameters.Add("UCFGSCBR", OracleType.NVarChar).Value = dwData["UCFGSCBR"].ToString(); 
          or1.Parameters.Add("UCFGSCBG", OracleType.NVarChar).Value = dwData["UCFGSCBG"].ToString(); 
          or1.Parameters.Add("UCFGSCBB", OracleType.NVarChar).Value = dwData["UCFGSCBB"].ToString(); 
          or1.Parameters.Add("UCFGIFVR", OracleType.NVarChar).Value = dwData["UCFGIFVR"].ToString(); 
          or1.Parameters.Add("UCFGIFVG", OracleType.NVarChar).Value = dwData["UCFGIFVG"].ToString(); 
          or1.Parameters.Add("UCFGIFVB", OracleType.NVarChar).Value = dwData["UCFGIFVB"].ToString(); 
          or1.Parameters.Add("UCFGIFHR", OracleType.NVarChar).Value = dwData["UCFGIFHR"].ToString(); 
          or1.Parameters.Add("UCFGIFHG", OracleType.NVarChar).Value = dwData["UCFGIFHG"].ToString(); 
          or1.Parameters.Add("UCFGIFHB", OracleType.NVarChar).Value = dwData["UCFGIFHB"].ToString(); 
          or1.Parameters.Add("UCFGHELPHR", OracleType.NVarChar).Value = dwData["UCFGHELPHR"].ToString(); 
          or1.Parameters.Add("UCFGHELPHG", OracleType.NVarChar).Value = dwData["UCFGHELPHG"].ToString(); 
          or1.Parameters.Add("UCFGHELPHB", OracleType.NVarChar).Value = dwData["UCFGHELPHB"].ToString(); 
          or1.Parameters.Add("UCFGK1R", OracleType.NVarChar).Value = dwData["UCFGK1R"].ToString(); 
          or1.Parameters.Add("UCFGK1G", OracleType.NVarChar).Value = dwData["UCFGK1G"].ToString(); 
          or1.Parameters.Add("UCFGK1B", OracleType.NVarChar).Value = dwData["UCFGK1B"].ToString(); 
          or1.Parameters.Add("UCFGK2R", OracleType.NVarChar).Value = dwData["UCFGK2R"].ToString(); 
          or1.Parameters.Add("UCFGK2G", OracleType.NVarChar).Value = dwData["UCFGK2G"].ToString(); 
          or1.Parameters.Add("UCFGK2B", OracleType.NVarChar).Value = dwData["UCFGK2B"].ToString(); 
          or1.Parameters.Add("UCFGS1R", OracleType.NVarChar).Value = dwData["UCFGS1R"].ToString(); 
          or1.Parameters.Add("UCFGS1G", OracleType.NVarChar).Value = dwData["UCFGS1G"].ToString(); 
          or1.Parameters.Add("UCFGS1B", OracleType.NVarChar).Value = dwData["UCFGS1B"].ToString(); 
          or1.Parameters.Add("UCFGS2R", OracleType.NVarChar).Value = dwData["UCFGS2R"].ToString(); 
          or1.Parameters.Add("UCFGS2G", OracleType.NVarChar).Value = dwData["UCFGS2G"].ToString(); 
          or1.Parameters.Add("UCFGS2B", OracleType.NVarChar).Value = dwData["UCFGS2B"].ToString(); 
          or1.Parameters.Add("UCFGRESR1", OracleType.NVarChar).Value = dwData["UCFGRESR1"].ToString(); 
          or1.Parameters.Add("UCFGRESG1", OracleType.NVarChar).Value = dwData["UCFGRESG1"].ToString(); 
          or1.Parameters.Add("UCFGRESB1", OracleType.NVarChar).Value = dwData["UCFGRESB1"].ToString(); 
          or1.Parameters.Add("UCFGRESR2", OracleType.NVarChar).Value = dwData["UCFGRESR2"].ToString(); 
          or1.Parameters.Add("UCFGRESG2", OracleType.NVarChar).Value = dwData["UCFGRESG2"].ToString(); 
          or1.Parameters.Add("UCFGRESB2", OracleType.NVarChar).Value = dwData["UCFGRESB2"].ToString(); 
          or1.Parameters.Add("UCFGRESR3", OracleType.NVarChar).Value = dwData["UCFGRESR3"].ToString(); 
          or1.Parameters.Add("UCFGRESG3", OracleType.NVarChar).Value = dwData["UCFGRESG3"].ToString(); 
          or1.Parameters.Add("UCFGRESB3", OracleType.NVarChar).Value = dwData["UCFGRESB3"].ToString(); 
          or1.Parameters.Add("UCFGRESR4", OracleType.NVarChar).Value = dwData["UCFGRESR4"].ToString(); 
          or1.Parameters.Add("UCFGRESG4", OracleType.NVarChar).Value = dwData["UCFGRESG4"].ToString(); 
          or1.Parameters.Add("UCFGRESB4", OracleType.NVarChar).Value = dwData["UCFGRESB4"].ToString(); 
          or1.Parameters.Add("UCFGRESR5", OracleType.NVarChar).Value = dwData["UCFGRESR5"].ToString(); 
          or1.Parameters.Add("UCFGRESG5", OracleType.NVarChar).Value = dwData["UCFGRESG5"].ToString(); 
          or1.Parameters.Add("UCFGRESB5", OracleType.NVarChar).Value = dwData["UCFGRESB5"].ToString(); 
          or1.Parameters.Add("UCFGRESR6", OracleType.NVarChar).Value = dwData["UCFGRESR6"].ToString(); 
          or1.Parameters.Add("UCFGRESG6", OracleType.NVarChar).Value = dwData["UCFGRESG6"].ToString(); 
          or1.Parameters.Add("UCFGRESB6", OracleType.NVarChar).Value = dwData["UCFGRESB6"].ToString(); 
          or1.Parameters.Add("UCFGRESR7", OracleType.NVarChar).Value = dwData["UCFGRESR7"].ToString(); 
          or1.Parameters.Add("UCFGRESG7", OracleType.NVarChar).Value = dwData["UCFGRESG7"].ToString(); 
          or1.Parameters.Add("UCFGRESB7", OracleType.NVarChar).Value = dwData["UCFGRESB7"].ToString(); 
          or1.Parameters.Add("UCFGRESR8", OracleType.NVarChar).Value = dwData["UCFGRESR8"].ToString(); 
          or1.Parameters.Add("UCFGRESG8", OracleType.NVarChar).Value = dwData["UCFGRESG8"].ToString(); 
          or1.Parameters.Add("UCFGRESB8", OracleType.NVarChar).Value = dwData["UCFGRESB8"].ToString(); 
          or1.Parameters.Add("UCFGRESR9", OracleType.NVarChar).Value = dwData["UCFGRESR9"].ToString(); 
          or1.Parameters.Add("UCFGRESG9", OracleType.NVarChar).Value = dwData["UCFGRESG9"].ToString(); 
          or1.Parameters.Add("UCFGRESB9", OracleType.NVarChar).Value = dwData["UCFGRESB9"].ToString(); 
          or1.Parameters.Add("UCFGRESR10", OracleType.NVarChar).Value = dwData["UCFGRESR10"].ToString(); 
          or1.Parameters.Add("UCFGRESG10", OracleType.NVarChar).Value = dwData["UCFGRESG10"].ToString(); 
          or1.Parameters.Add("UCFGRESB10", OracleType.NVarChar).Value = dwData["UCFGRESB10"].ToString(); 
          or1.Parameters.Add("UCFGRESR11", OracleType.NVarChar).Value = dwData["UCFGRESR11"].ToString(); 
          or1.Parameters.Add("UCFGRESG11", OracleType.NVarChar).Value = dwData["UCFGRESG11"].ToString(); 
          or1.Parameters.Add("UCFGRESB11", OracleType.NVarChar).Value = dwData["UCFGRESB11"].ToString(); 
          or1.Parameters.Add("UCFGRESR12", OracleType.NVarChar).Value = dwData["UCFGRESR12"].ToString(); 
          or1.Parameters.Add("UCFGRESG12", OracleType.NVarChar).Value = dwData["UCFGRESG12"].ToString(); 
          or1.Parameters.Add("UCFGRESB12", OracleType.NVarChar).Value = dwData["UCFGRESB12"].ToString(); 
          or1.Parameters.Add("UCFGRESR13", OracleType.NVarChar).Value = dwData["UCFGRESR13"].ToString(); 
          or1.Parameters.Add("UCFGRESG13", OracleType.NVarChar).Value = dwData["UCFGRESG13"].ToString(); 
          or1.Parameters.Add("UCFGRESB13", OracleType.NVarChar).Value = dwData["UCFGRESB13"].ToString(); 
          or1.Parameters.Add("UCFGRESR14", OracleType.NVarChar).Value = dwData["UCFGRESR14"].ToString(); 
          or1.Parameters.Add("UCFGRESG14", OracleType.NVarChar).Value = dwData["UCFGRESG14"].ToString(); 
          or1.Parameters.Add("UCFGRESB14", OracleType.NVarChar).Value = dwData["UCFGRESB14"].ToString(); 
          or1.Parameters.Add("UCFGRESR15", OracleType.NVarChar).Value = dwData["UCFGRESR15"].ToString(); 
          or1.Parameters.Add("UCFGRESG15", OracleType.NVarChar).Value = dwData["UCFGRESG15"].ToString(); 
          or1.Parameters.Add("UCFGRESB15", OracleType.NVarChar).Value = dwData["UCFGRESB15"].ToString(); 
          or1.Parameters.Add("UCFGRESR16", OracleType.NVarChar).Value = dwData["UCFGRESR16"].ToString(); 
          or1.Parameters.Add("UCFGRESG16", OracleType.NVarChar).Value = dwData["UCFGRESG16"].ToString(); 
          or1.Parameters.Add("UCFGRESB16", OracleType.NVarChar).Value = dwData["UCFGRESB16"].ToString(); 
          or1.Parameters.Add("UCFGRESR17", OracleType.NVarChar).Value = dwData["UCFGRESR17"].ToString(); 
          or1.Parameters.Add("UCFGRESG17", OracleType.NVarChar).Value = dwData["UCFGRESG17"].ToString(); 
          or1.Parameters.Add("UCFGRESB17", OracleType.NVarChar).Value = dwData["UCFGRESB17"].ToString(); 
          or1.Parameters.Add("UCFGRESR18", OracleType.NVarChar).Value = dwData["UCFGRESR18"].ToString(); 
          or1.Parameters.Add("UCFGRESG18", OracleType.NVarChar).Value = dwData["UCFGRESG18"].ToString(); 
          or1.Parameters.Add("UCFGRESB18", OracleType.NVarChar).Value = dwData["UCFGRESB18"].ToString(); 
          or1.Parameters.Add("UCFGRESR19", OracleType.NVarChar).Value = dwData["UCFGRESR19"].ToString(); 
          or1.Parameters.Add("UCFGRESG19", OracleType.NVarChar).Value = dwData["UCFGRESG19"].ToString(); 
          or1.Parameters.Add("UCFGRESB19", OracleType.NVarChar).Value = dwData["UCFGRESB19"].ToString(); 
          or1.Parameters.Add("UCFGRESR20", OracleType.NVarChar).Value = dwData["UCFGRESR20"].ToString(); 
          or1.Parameters.Add("UCFGRESG20", OracleType.NVarChar).Value = dwData["UCFGRESG20"].ToString(); 
          or1.Parameters.Add("UCFGRESB20", OracleType.NVarChar).Value = dwData["UCFGRESB20"].ToString(); 
          or1.Parameters.Add("UCFGRESR21", OracleType.NVarChar).Value = dwData["UCFGRESR21"].ToString(); 
          or1.Parameters.Add("UCFGRESG21", OracleType.NVarChar).Value = dwData["UCFGRESG21"].ToString(); 
          or1.Parameters.Add("UCFGRESB21", OracleType.NVarChar).Value = dwData["UCFGRESB21"].ToString(); 
          or1.Parameters.Add("UCFGRESR22", OracleType.NVarChar).Value = dwData["UCFGRESR22"].ToString(); 
          or1.Parameters.Add("UCFGRESG22", OracleType.NVarChar).Value = dwData["UCFGRESG22"].ToString(); 
          or1.Parameters.Add("UCFGRESB22", OracleType.NVarChar).Value = dwData["UCFGRESB22"].ToString(); 
          or1.Parameters.Add("UCFGRESR23", OracleType.NVarChar).Value = dwData["UCFGRESR23"].ToString(); 
          or1.Parameters.Add("UCFGRESG23", OracleType.NVarChar).Value = dwData["UCFGRESG23"].ToString(); 
          or1.Parameters.Add("UCFGRESB23", OracleType.NVarChar).Value = dwData["UCFGRESB23"].ToString(); 
          or1.Parameters.Add("UCFGRESR24", OracleType.NVarChar).Value = dwData["UCFGRESR24"].ToString(); 
          or1.Parameters.Add("UCFGRESG24", OracleType.NVarChar).Value = dwData["UCFGRESG24"].ToString(); 
          or1.Parameters.Add("UCFGRESB24", OracleType.NVarChar).Value = dwData["UCFGRESB24"].ToString(); 
          or1.Parameters.Add("UCFGRESR25", OracleType.NVarChar).Value = dwData["UCFGRESR25"].ToString(); 
          or1.Parameters.Add("UCFGRESG25", OracleType.NVarChar).Value = dwData["UCFGRESG25"].ToString(); 
          or1.Parameters.Add("UCFGRESB25", OracleType.NVarChar).Value = dwData["UCFGRESB25"].ToString(); 
          or1.Parameters.Add("UCFGRESR26", OracleType.NVarChar).Value = dwData["UCFGRESR26"].ToString(); 
          or1.Parameters.Add("UCFGRESG26", OracleType.NVarChar).Value = dwData["UCFGRESG26"].ToString(); 
          or1.Parameters.Add("UCFGRESB26", OracleType.NVarChar).Value = dwData["UCFGRESB26"].ToString(); 
          or1.Parameters.Add("UCFGRESR27", OracleType.NVarChar).Value = dwData["UCFGRESR27"].ToString(); 
          or1.Parameters.Add("UCFGRESG27", OracleType.NVarChar).Value = dwData["UCFGRESG27"].ToString(); 
          or1.Parameters.Add("UCFGRESB27", OracleType.NVarChar).Value = dwData["UCFGRESB27"].ToString(); 
          or1.Parameters.Add("UCFGFONT1", OracleType.NVarChar).Value = dwData["UCFGFONT1"].ToString(); 
          or1.Parameters.Add("UCFGFONT2", OracleType.NVarChar).Value = dwData["UCFGFONT2"].ToString(); 
          or1.Parameters.Add("UCFGFONT3", OracleType.NVarChar).Value = dwData["UCFGFONT3"].ToString(); 
          or1.Parameters.Add("UCFGFONT4", OracleType.NVarChar).Value = dwData["UCFGFONT4"].ToString(); 
          or1.Parameters.Add("UCFGFONT5", OracleType.NVarChar).Value = dwData["UCFGFONT5"].ToString(); 
          or1.Parameters.Add("UCFGFONT6", OracleType.NVarChar).Value = dwData["UCFGFONT6"].ToString(); 
          or1.Parameters.Add("UCFGFONT7", OracleType.NVarChar).Value = dwData["UCFGFONT7"].ToString(); 
          or1.Parameters.Add("UCFGFONT8", OracleType.NVarChar).Value = dwData["UCFGFONT8"].ToString(); 
          or1.Parameters.Add("UCFGPARMNAME1", OracleType.NVarChar).Value = dwData["UCFGPARMNAME1"].ToString(); 
          or1.Parameters.Add("UCFGPARMWERT1", OracleType.NVarChar).Value = dwData["UCFGPARMWERT1"].ToString(); 
          or1.Parameters.Add("UCFGPARMNAME2", OracleType.NVarChar).Value = dwData["UCFGPARMNAME2"].ToString(); 
          or1.Parameters.Add("UCFGPARMWERT2", OracleType.NVarChar).Value = dwData["UCFGPARMWERT2"].ToString(); 
          or1.Parameters.Add("UCFGPARMNAME3", OracleType.NVarChar).Value = dwData["UCFGPARMNAME3"].ToString(); 
          or1.Parameters.Add("UCFGPARMWERT3", OracleType.NVarChar).Value = dwData["UCFGPARMWERT3"].ToString(); 
          or1.Parameters.Add("UCFGPARMNAME4", OracleType.NVarChar).Value = dwData["UCFGPARMNAME4"].ToString(); 
          or1.Parameters.Add("UCFGPARMWERT4", OracleType.NVarChar).Value = dwData["UCFGPARMWERT4"].ToString(); 
          or1.Parameters.Add("UCFGPARMNAME5", OracleType.NVarChar).Value = dwData["UCFGPARMNAME5"].ToString(); 
          or1.Parameters.Add("UCFGPARMWERT5", OracleType.NVarChar).Value = dwData["UCFGPARMWERT5"].ToString(); 
          or1.Parameters.Add("UCFGPARMNAME6", OracleType.NVarChar).Value = dwData["UCFGPARMNAME6"].ToString(); 
          or1.Parameters.Add("UCFGPARMWERT6", OracleType.NVarChar).Value = dwData["UCFGPARMWERT6"].ToString(); 
          or1.Parameters.Add("UCFGPARMNAME7", OracleType.NVarChar).Value = dwData["UCFGPARMNAME7"].ToString(); 
          or1.Parameters.Add("UCFGPARMWERT7", OracleType.NVarChar).Value = dwData["UCFGPARMWERT7"].ToString(); 
          or1.Parameters.Add("UCFGPARMNAME8", OracleType.NVarChar).Value = dwData["UCFGPARMNAME8"].ToString(); 
          or1.Parameters.Add("UCFGPARMWERT8", OracleType.NVarChar).Value = dwData["UCFGPARMWERT8"].ToString(); 
          or1.Parameters.Add("UCFGPARMNAME9", OracleType.NVarChar).Value = dwData["UCFGPARMNAME9"].ToString(); 
          or1.Parameters.Add("UCFGPARMWERT9", OracleType.NVarChar).Value = dwData["UCFGPARMWERT9"].ToString(); 
          or1.Parameters.Add("UCFGPARMNAME10", OracleType.NVarChar).Value = dwData["UCFGPARMNAME10"].ToString(); 
          or1.Parameters.Add("UCFGPARMWERT10", OracleType.NVarChar).Value = dwData["UCFGPARMWERT10"].ToString(); 
          or1.Parameters.Add("UCFGPARMNAME11", OracleType.NVarChar).Value = dwData["UCFGPARMNAME11"].ToString(); 
          or1.Parameters.Add("UCFGPARMWERT11", OracleType.NVarChar).Value = dwData["UCFGPARMWERT11"].ToString(); 
          or1.Parameters.Add("UCFGPARMNAME12", OracleType.NVarChar).Value = dwData["UCFGPARMNAME12"].ToString(); 
          or1.Parameters.Add("UCFGPARMWERT12", OracleType.NVarChar).Value = dwData["UCFGPARMWERT12"].ToString(); 
          or1.Parameters.Add("UCFGPARMNAME13", OracleType.NVarChar).Value = dwData["UCFGPARMNAME13"].ToString(); 
          or1.Parameters.Add("UCFGPARMWERT13", OracleType.NVarChar).Value = dwData["UCFGPARMWERT13"].ToString(); 
          or1.Parameters.Add("UCFGPARMNAME14", OracleType.NVarChar).Value = dwData["UCFGPARMNAME14"].ToString(); 
          or1.Parameters.Add("UCFGPARMWERT14", OracleType.NVarChar).Value = dwData["UCFGPARMWERT14"].ToString(); 
          or1.Parameters.Add("UCFGPARMNAME15", OracleType.NVarChar).Value = dwData["UCFGPARMNAME15"].ToString(); 
          or1.Parameters.Add("UCFGPARMWERT15", OracleType.NVarChar).Value = dwData["UCFGPARMWERT15"].ToString(); 
          or1.Parameters.Add("UCFGPARMNAME16", OracleType.NVarChar).Value = dwData["UCFGPARMNAME16"].ToString(); 
          or1.Parameters.Add("UCFGPARMWERT16", OracleType.NVarChar).Value = dwData["UCFGPARMWERT16"].ToString(); 
          or1.Parameters.Add("UCFGEDITEDGE", OracleType.NVarChar).Value = dwData["UCFGEDITEDGE"].ToString(); 
          or1.Parameters.Add("UCFGEDITY", OracleType.NVarChar).Value = dwData["UCFGEDITY"].ToString(); 
          or1.Parameters.Add("UCFGFONTFAKT1", OracleType.NVarChar).Value = dwData["UCFGFONTFAKT1"].ToString(); 
          or1.Parameters.Add("UCFGFONTFAKT2", OracleType.NVarChar).Value = dwData["UCFGFONTFAKT2"].ToString(); 
          or1.Parameters.Add("UCFGSHIFT", OracleType.NVarChar).Value = dwData["UCFGSHIFT"].ToString(); 
          or1.Parameters.Add("UCFGZUONR1", OracleType.NVarChar).Value = dwData["UCFGZUONR1"].ToString(); 
          or1.Parameters.Add("UCFGZUONR2", OracleType.NVarChar).Value = dwData["UCFGZUONR2"].ToString(); 
          or1.Parameters.Add("UCFGZUONR3", OracleType.NVarChar).Value = dwData["UCFGZUONR3"].ToString(); 
          or1.Parameters.Add("UCFGZUONR4", OracleType.NVarChar).Value = dwData["UCFGZUONR4"].ToString(); 
          or1.Parameters.Add("UCFGZUONR5", OracleType.NVarChar).Value = dwData["UCFGZUONR5"].ToString(); 
          or1.Parameters.Add("UCFGZUONR6", OracleType.NVarChar).Value = dwData["UCFGZUONR6"].ToString(); 
          or1.Parameters.Add("UCFGZUONR7", OracleType.NVarChar).Value = dwData["UCFGZUONR7"].ToString(); 
          or1.Parameters.Add("UCFGZUONR8", OracleType.NVarChar).Value = dwData["UCFGZUONR8"].ToString(); 
          or1.Parameters.Add("UCFGZUONR9", OracleType.NVarChar).Value = dwData["UCFGZUONR9"].ToString(); 
          or1.Parameters.Add("UCFGZUONR10", OracleType.NVarChar).Value = dwData["UCFGZUONR10"].ToString(); 
          or1.Parameters.Add("UCFGZUONR11", OracleType.NVarChar).Value = dwData["UCFGZUONR11"].ToString(); 
          or1.Parameters.Add("UCFGZUONR12", OracleType.NVarChar).Value = dwData["UCFGZUONR12"].ToString(); 
          or1.Parameters.Add("UCFGZUONR13", OracleType.NVarChar).Value = dwData["UCFGZUONR13"].ToString(); 
          or1.Parameters.Add("UCFGZUONR14", OracleType.NVarChar).Value = dwData["UCFGZUONR14"].ToString(); 
          or1.Parameters.Add("UCFGZUONR15", OracleType.NVarChar).Value = dwData["UCFGZUONR15"].ToString(); 
          or1.Parameters.Add("UCFGZUONR16", OracleType.NVarChar).Value = dwData["UCFGZUONR16"].ToString(); 
          or1.Parameters.Add("UCFGZUONR17", OracleType.NVarChar).Value = dwData["UCFGZUONR17"].ToString(); 
          or1.Parameters.Add("UCFGZUONR18", OracleType.NVarChar).Value = dwData["UCFGZUONR18"].ToString(); 
          or1.Parameters.Add("UCFGZUONR19", OracleType.NVarChar).Value = dwData["UCFGZUONR19"].ToString(); 
          or1.Parameters.Add("UCFGZUONR20", OracleType.NVarChar).Value = dwData["UCFGZUONR20"].ToString(); 
          or1.Parameters.Add("UCFGZUONR21", OracleType.NVarChar).Value = dwData["UCFGZUONR21"].ToString(); 
          or1.Parameters.Add("UCFGZUONR22", OracleType.NVarChar).Value = dwData["UCFGZUONR22"].ToString(); 
          or1.Parameters.Add("UCFGZUONR23", OracleType.NVarChar).Value = dwData["UCFGZUONR23"].ToString(); 
          or1.Parameters.Add("UCFGZUONR24", OracleType.NVarChar).Value = dwData["UCFGZUONR24"].ToString(); 
          or1.Parameters.Add("UCFGZUONR25", OracleType.NVarChar).Value = dwData["UCFGZUONR25"].ToString(); 
          or1.Parameters.Add("UCFGZUONR26", OracleType.NVarChar).Value = dwData["UCFGZUONR26"].ToString(); 
          or1.Parameters.Add("UCFGZUONR27", OracleType.NVarChar).Value = dwData["UCFGZUONR27"].ToString(); 
          or1.Parameters.Add("UCFGZUONR28", OracleType.NVarChar).Value = dwData["UCFGZUONR28"].ToString(); 
          or1.Parameters.Add("UCFGZUONR29", OracleType.NVarChar).Value = dwData["UCFGZUONR29"].ToString(); 
          or1.Parameters.Add("UCFGZUONR30", OracleType.NVarChar).Value = dwData["UCFGZUONR30"].ToString(); 
          or1.Parameters.Add("UCFGZUONR31", OracleType.NVarChar).Value = dwData["UCFGZUONR31"].ToString(); 
          or1.Parameters.Add("UCFGZUONR32", OracleType.NVarChar).Value = dwData["UCFGZUONR32"].ToString(); 
          or1.Parameters.Add("UCFGZUONR33", OracleType.NVarChar).Value = dwData["UCFGZUONR33"].ToString(); 
          or1.Parameters.Add("UCFGZUONR34", OracleType.NVarChar).Value = dwData["UCFGZUONR34"].ToString(); 
          or1.Parameters.Add("UCFGZUONR35", OracleType.NVarChar).Value = dwData["UCFGZUONR35"].ToString(); 
          or1.Parameters.Add("UCFGZUONR36", OracleType.NVarChar).Value = dwData["UCFGZUONR36"].ToString(); 
          or1.Parameters.Add("UCFGZUONR37", OracleType.NVarChar).Value = dwData["UCFGZUONR37"].ToString(); 
          or1.Parameters.Add("UCFGZUONR38", OracleType.NVarChar).Value = dwData["UCFGZUONR38"].ToString(); 
          or1.Parameters.Add("UCFGZUONR39", OracleType.NVarChar).Value = dwData["UCFGZUONR39"].ToString(); 
          or1.Parameters.Add("UCFGZUONR40", OracleType.NVarChar).Value = dwData["UCFGZUONR40"].ToString(); 
          or1.Parameters.Add("UCFGZUONR41", OracleType.NVarChar).Value = dwData["UCFGZUONR41"].ToString(); 
          or1.Parameters.Add("UCFGZUONR42", OracleType.NVarChar).Value = dwData["UCFGZUONR42"].ToString(); 
          or1.Parameters.Add("UCFGZUONR43", OracleType.NVarChar).Value = dwData["UCFGZUONR43"].ToString(); 
          or1.Parameters.Add("UCFGZUONR44", OracleType.NVarChar).Value = dwData["UCFGZUONR44"].ToString(); 
          or1.Parameters.Add("UCFGZUONR45", OracleType.NVarChar).Value = dwData["UCFGZUONR45"].ToString(); 
          or1.Parameters.Add("UCFGZUONR46", OracleType.NVarChar).Value = dwData["UCFGZUONR46"].ToString(); 
          or1.Parameters.Add("UCFGZUONR47", OracleType.NVarChar).Value = dwData["UCFGZUONR47"].ToString(); 
          or1.Parameters.Add("UCFGZUONR48", OracleType.NVarChar).Value = dwData["UCFGZUONR48"].ToString(); 
          or1.Parameters.Add("UCFGZUONR49", OracleType.NVarChar).Value = dwData["UCFGZUONR49"].ToString(); 
          or1.Parameters.Add("UCFGZUONR50", OracleType.NVarChar).Value = dwData["UCFGZUONR50"].ToString(); 
          or1.Parameters.Add("UCFGFILLER1", OracleType.NVarChar).Value = dwData["UCFGFILLER1"].ToString(); 
          or1.Parameters.Add("UCFGFILLER2", OracleType.NVarChar).Value = dwData["UCFGFILLER2"].ToString(); 
                    #endregion
                    break; 
                default:
                    break;
            }


            Connect2Proxy(or1);
        }
    }
}
